Good morning,
I'm looking at TDE and am currently a little confused.
If I interrogate sys.databases, I see that myDatabase has the "is_encrypted" flag set to 0.
If I interrogate the sys.dm_encryption_keys view, under the correct database, I see that the encryption_state is set to 3 (which is Encrypted)...
Surely if the value for encryption_state is 3, then the "is_encrypted" flag should be 1?
Am I missing something?
Regards
Andy